SaTrans

Logical Entity Name | SaTrans
Default Table Name | SaTrans
Physical Only | NO
Owner | dbo
Definition |
Note |

SaTrans Columns

ColumnName | Domain | Datatype | NULL | Definition
SaTransID |  | int | NO |
SyStudentID |  | int | NO |
AdEnrollID |  | int | NO |
Source |  | char(1) | NO |
Type |  | char(1) | NO |
SyCampusID |  | int | NO |
SaBillCode |  | char(8) | NO |
TranNum |  | numeric(4, 0) | NO |
Descrip |  | varchar(500) | YES |
Status |  | char(1) | NO |
Date |  | datetime | NO |
PostDate |  | datetime | NO |
Amount |  | money | NO |
PaymentType |  | char(1) | YES |
Discount |  | money | NO |
Payments |  | money | NO |
BatchNo |  | char(8) | NO |
SaRevenueDetailID |  | int | YES |
FaPmtPeriodID |  | int | NO |
AcademicYear |  | numeric(3, 0) | NO |
AdTermID |  | int | NO |
Ref |  | char(75) | NO |
CheckNo |  | varchar(20) | NO |
SaCCID |  | int | YES |
ReceiptNo |  | varchar(16) | YES |
DateApplied |  | datetime | YES |
SentBack |  | bit | NO |
SaBankAccountID |  | int | YES |
SaBankDepID |  | int | NO |
AmRepID |  | int | NO |
CommRate |  | money | NO |
CommPaid |  | bit | NO |
CommDate |  | datetime | YES |
GLPost |  | bit | NO |
PostAccount |  | nvarchar(100) | NO |
OffsetAccount |  | nvarchar(100) | NO |
FaStudentAidID |  | int | NO |
FADisbID |  | int | YES |
FaRefundID |  | int | YES |
SaBillingBatchID |  | int | YES |
SaRefundCalcID |  | int | YES |
AddUserID |  | int | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
AmDepositID |  | int | YES |
CCAuthNum |  | nchar(14) | YES |
CCDeclineCode |  | char(10) | YES |
SyAddressID |  | int | YES |
SaQTBatchID |  | int | YES |
SA1098T |  | char(1) | NO |
SaACHBatchID |  | int | YES |
DateReceiptPrinted |  | datetime | YES |
SaCreditCardBatchId |  | int | YES |
saCashDrawerSessionID |  | int | YES |
ManualCheckExtractFlag |  | bit | YES |
AdCourseID |  | int | YES |
SaTuitionDiscountPolicyID |  | int | YES |
OriginalSaTransId |  | int | YES |
AmAgencyCCID |  | int | YES |
CheckStatus |  | char(1) | NO |
CheckClearedDate |  | datetime | YES |
Sa1098TPrevYear |  | bit | NO |
AdClassSchedID |  | int | YES |
MerchantProcessingCode |  | varchar(19) | YES |
FaStudentAyPaymentPeriodId |  | int | YES |
EFTNumber |  | varchar(20) | YES |
EFTStatus |  | char(1) | YES |
EFTClearedDate |  | datetime | YES |
SaCourseRefundPolicyId |  | int | YES |
CourseAmountToRetain |  | money | YES |
RegAdTermID |  | int | YES |
ProcessByAutomation |  | bit | NO |
AdFeesId |  | int | YES |
GLStatusFlag |  | bit | NO |
IsReIssue |  | bit | NO |
IsInPendingQueue |  | bit | NO |
IsCNFReconciled |  | bit | NO |
TransDueDate |  | datetime | YES |
SaStudentBankAccountId |  | int | YES |
DRN |  | nvarchar(23) | YES |
VRN |  | nvarchar(23) | YES |

SaTrans Primary and Unique Keys

Key Name | Key Type | Keys
SaTrans_SyCampusID_SaBankDepID_Type_Ref_Source_SaTransID_U_N_IDX | Index | SyCampusID, SaBankDepID, Type, Ref, Source, SaTransID
SaTrans_SaTransID_U_C_IDX | PrimaryKey | SaTransID
SaTrans_AdEnrollId_AdTermId_SaBillCode_Source_Type_Amount_SaTransID_U_N_IDX | Index | AdEnrollID, AdTermID, SaBillCode, Source, SaTransID
SaTrans_PostDate_Source_SaBankAccountID_SaTransID_U_N_IDX | Index | PostDate, Source, SaBankAccountID, SaTransID
SaTrans_SyCampusId_AdEnrollId_AdTermId_Type_Amount_Date_SaTransId_U_N_IDX | Index | SyCampusID, AdEnrollID, AdTermID, Type, Amount, Date, SaTransID
Nk_SaTrans_SyCampusId_AdEnrollId_AdTermId_Type_Amount_Date_SaTransId_U_N_IDX | Index | SyCampusID, AdEnrollID, AdTermID, Type, Amount, Date, SaTransID

SaTrans Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
saCashDrawerSession | Non-Identifying | Zero or One to Zero or More | FK_saTrans.saCashDrawerSessionID_saCashDrawerSession.saCashDrawerSessionID |  |  | saCashDrawerSessionID | NO | YES
AdClassSched | Non-Identifying | Zero or One to Zero or More | Fk_SaTrans_AdClassSchedID_AdClassSched_AdClassSchedID |  |  | AdClassSchedID | NO | YES
AdCourse | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_AdCourseID_AdCourse_AdCourseID |  |  | AdCourseID | NO | YES
AdFees | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_AdFeesId_AdFees_AdFeesId |  |  | AdFeesId | NO | YES
AmAgencyCC | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_AmAgencyCCID_AmAgencyCC_AmAgencyCCID |  |  | AmAgencyCCID | NO | YES
FaStudentAYPaymentPeriod | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_FaStudentAyPaymentPeriodId_FaStudentAyPaymentPeriod_FaStudentAyPaymentPeriodId |  |  | FaStudentAyPaymentPeriodId | NO | YES
SaACHBatch | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_SaACHBatchID_SaACHBatch_SaACHBatchID |  |  | SaACHBatchID | NO | YES
SaCourseRefundPolicy | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_SaCourseRefundPolicyId_SaCourseRefundPolicy_SaCourseRefundPolicyId |  |  | SaCourseRefundPolicyId | NO | YES
SaStudentBankAccount | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_SaStudentBankAccountId_SaStudentBankAccount_SaStudentBankAccountId |  |  | SaStudentBankAccountId | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
SaAutoStipendPaymentQueue | Non-Identifying | One To Zero or More | FK_SaAutoStipendPaymentQueueSaTransID_SaTransSaTransID |  |  |  | NO | YES
SaDisbReceiptNotification | Non-Identifying | One To Zero or More | FK_SaDisbReceiptNotificationSaTransID_SaTransSaTransID |  |  |  | NO | YES
SaStudentLedgerTermUpdatesArchive | Non-Identifying | One To Zero or More | FK_SaStudentLedgerTermUpdatesArchive_SaTransID_SaTrans_SaTransID |  |  |  | NO | YES
SaTransCourse | Non-Identifying | One To Zero or More | FK_SaTransCourse_SaTransID_SaTrans_SaTransID |  |  |  | NO | YES
SaTransCourseAmount | Non-Identifying | One To Zero or More | FK_SaTransCourseAmount_SaTransId_SaTrans_SaTransId |  |  |  | NO | YES
SaTransFee | Non-Identifying | One To Zero or More | FK_SaTransFee_SaTransID_SaTrans_SaTransID |  |  |  | NO | YES

SaTrans Check Constraints

Check Constraint Name | CheckConstraint

SaTrans Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SaTrans Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAccountTransaction | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaTrans | NO |  |  |

SaTrans Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ElectronicPaymentProcessing
Logical | LedgerCard_Billing
Logical | Refunds_Stipends
Logical | Revenue_GL_BankDeposit
Logical | StudentPayments_Collections
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

SaTrans Data Movement Rules

Name | Type | Rule Text/Value